/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package sv.com.intesal.general.sql;

/**
 *
 * @author ejerez
 */
public class SQLSucursal {

    public static final String insert = "INSERT INTO SUCURSAL(nombre_s,estado_s)VALUES(?,?)";
    public static final String update = "UPDATE SUCURSAL SET nombre_s=?,estado_s=? where codigo_s=?";
    public static final String getSucursal = "SELECT s.codigo_s,s.nombre_s,s.estado_s FROM SUCURSAL as s order by s.nombre_s";
    public static final String getSucursalActivos = "SELECT s.codigo_s,s.nombre_s,s.estado_s FROM SUCURSAL as s where s.estado_s='A' order by s.nombre_s";
    public static final String getSucursal_x_Codigo = "SELECT s.codigo_s,s.nombre_s,s.estado_s FROM SUCURSAL as s where s.codigo_s=?";
}
